package com.tanhua.admin.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tanhua.model.db.Log;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface LogMapper extends BaseMapper<Log> {

    //根据类型和日期查询
    @Select("select count(user_Id) from tb_log where type=#{type} and log_time=#{logTime} ")
    Integer queryByTypeAndLogTime(@Param("type") String type, @Param("logTime") String logTime);

    //根据日期查询
    @Select("select count(user_Id) from tb_log where log_time=#{logTime} ")
    Integer queryByLogTime(String logTime);

    //查询次日留存
    @Select("select count(DISTINCT user_Id) from tb_log where  log_time=#{today} and user_id in \n" +
            "(\n" +
            "\t select user_id from tb_log where type='0102' and log_time=#{yesterday} \n" +
            ")")
    Integer queryMumRetention1d(@Param("today") String today,@Param("yesterday")  String yesterday);
}
